Mode 2 - Internal Server

In Mode 2, DB-Gate runs as server job on a dedicated subsystem. This subsystem must be started before processing any SQL statements. The product can be configured to start this subsystem automatically after every IPL.

This mode has no initial extra processing and requires fewer memory resources than Mode 1.

Before You Begin

1. Ensure that no SQL are using DB-Gate. This should be done by your organization’s IT Administrator.
2. Set a password for the user profile SECURITYBP (which initially has a password of *NONE) and set the password expiration interval (PWDEXPITV) to *NOMAX. SECURITYBP is a power user. The user is never used for signing on to the system, and must be given a strong password.

Activation

To activate DB-Gate to run in Internal Server Mode (2):

1. Ensure DB-Gate mode is set to Internal Server (2) as follows:
1. Select 81. System Configuration from the DB-Gate main menu. The DB Directory Entry System Configuration menu appears.

​ DBPARMR​           ​ DB Directory Entry System Configuration​  ​ 17/01/21​ 16:29:47​                                                                                   ​ Select one of the following:                  ​                                                                                                                   ​ DB-Gate​                                                                         ​  1. General Definitions           ​                                              ​  2. JVM Settings​                                                                                                                                                 ​  9. Log Retention                 ​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ​ General​                                                                           ​ 98. Driver Licenses ​                 ​ Selection ===>​ ​   ​                        ​ 99. Copyright Notice​                                                                                                  ​ Release ID . . . . . . . . . . . . . .​ ​ 02.60 19-05-20 ​ ​  788C500​  41A​ EP10​   2 ​ Authorization code . . . . . . . . . .​ ​ ​XXXXXXXXXX ​ 123         ​ 2​  ​ RLDEV    ​                                                                                                                                                                  ​ F3=Exit    F22=Enter Authorization Code                      F12=Cancel    ​     ​                                                                             ​  ​  ​

2. Select 1. General Definitions from the DB Directory Entry System Configuration menu. The General Definitions screen appears.

​                             ​ General Definitions​            ​ 17/01/21​ 18:33:48​                                                                                   ​ Type options, press Enter.​                                                                                                                                       ​ Run mode  . . . . . . . . . . . . . .​ ​ 2​     ​ 1=Inline (no pre-activation)​                                                    ​ 2=Internal server​                                                               ​ 3=External server​                                                                                                  ​ Log level (errors are always logged).​ ​ 2​     ​ 1=No Log​                                                                        ​ 2=Connects only​                                                                 ​ 4=All (only first FETCH logged)​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              ​ F3=Exit   F12=Cancel                                                      ​      ​                                                                             ​  ​  ​

3. Set the Run mode to 2 (if set to another mode) and press Enter continuously (usually 2 or 3 times) to return to the DB-Gate main menu.
2. Activate the server as follows:
1. Select 2. Activation from the DB-Gate main menu. The Activation - Server Mode menu appears.

​ DBSETMN​                  ​  Activation - Server Mode ​        ​           DB-Gate​                                                               ​ System:​ ​ RLDEV   ​  ​ DB-Gate operates in Inline or Server mode. Server mode requires activation.   ​                                                                                   ​ Internal Server Mode  ​                 ​ External Server Mode      ​              ​  1. Activate Server                ​    ​ Activation / De-activation is performed ​  2. De-activate Server             ​    ​ on the external server.                 ​  5. Work with Active Jobs          ​    ​ See manual for details.              ​                                                                                    ​ 11. Activate Server at IPL             ​                                         ​ 12. Do Not Activate Server at IPL      ​                                                                                                                                                                                                           ​ Monitor Internal/External Server​       ​ Special​                                 ​ 31. Work with Active Sessions   ​       ​ 71. Run DB-Gate Performance Test   ​                                             ​ 79. Recreate Data Queues      ​                                                                                                                                                                            ​ Selection or command                  ​                                          ​ ===>​                                                                                                                                                           ​  ​ F3=Exit   F4=Prompt   F9=Retrieve   F12=Cancel                                ​  ​ F13=Information Assistant  F16=System main menu                                 ​                                                                               ​  ​

2. Select 1. Activate Server from the Activation - Server Mode menu. DB-Gate begins to operate in Internal Server Mode. A message appears at the bottom of the screen indicating this.
3. Select 5. Work with Active Jobs from the Activation - Server Mode menu to verify that DB-Gate is working. The Work with Subsystem Jobs screen appears and displays active jobs within the ZDBGATE Subsystem Jobs and their status.

​                           ​ Work with Subsystem Jobs​                  ​ RLDEV   ​   ​  ​       ​  ​                                            ​ 24/01/21​  14:42:36 UTC​  ​ Subsystem  . . . . . . . . . . :​  ​ ZDBGATE   ​                                                                                                                    ​ Type options, press Enter.​                                                        ​ 2=Change​  ​ 3=Hold​  ​ 4=End​  ​ 5=Work with​  ​ 6=Release​  ​ 7=Display message​         ​ 8=Work with spooled files​  ​ 13=Disconnect​                                                                                                                                                                                                       ​ Opt​ ​ Job​        ​ User​       ​ Type​    ​ -----Status-----​ ​ Function​                ​   ​  ​ DBMONITOR ​ ​ SECURITYBP​ ​ AUTO   ​ ​ ACTIVE ​ ​        ​ ​ DLY-120       ​          ​   ​  ​ DP24144053​ ​ SECURITYBP​ ​ BATCH  ​ ​ ACTIVE ​ ​        ​ ​ PGM-jvmStartPa​                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              ​  ​  ​       Bottom​  ​ Parameters or command​                                                           ​ ===>​                                                                          ​  ​ F3=Exit​     ​ F4=Prompt​  ​ F5=Refresh​  ​ F9=Retrieve​  ​ F11=Display schedule data​   ​ F12=Cancel​  ​ F17=Top​    ​ F18=Bottom​                                                                                                                              ​

Automatic Activation upon Startup

Internal Server Mode can be set to automatically activate upon startup of the IBM System Initial Program Load (IPL) from the Activation screen.

• To enable automatic activation, select 11. Activate Server at IPL.
• To disable automatic activation, select 12. Do Not Activate Server at IPL.
• You can verify automatic activation status by typing DSPJOBLOG at the command prompt.